package com.cs.beneficios.web.action;

import co.gov.medellin.ssti.sub.model.dao.IVerificacionDAO;
import co.gov.medellin.ssti.sub.model.dao.impl.VerificacionDAOImpl;

import com.cs.beneficios.business.entity.VerificacionDAO;
import com.cs.beneficios.common.ConnectionFactory;
import com.cs.paoyer.administration.business.model.UserVO;

import java.io.IOException;

import java.sql.SQLException;

import java.util.Collection;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class IngresoArchivoVerificacionAction extends Action {
	/**
	 * This is the main action called from the Struts framework.
	 * 
	 * @param mapping
	 *            The ActionMapping used to select this instance.
	 * @param form
	 *            The optional ActionForm bean for this request.
	 * @param request
	 *            The HTTP Request we are processing.
	 * @param response
	 *            The HTTP Response we are processing.
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {

		ConnectionFactory cf = new ConnectionFactory();
		HttpSession session = request.getSession();
		UserVO user = (UserVO) session.getAttribute("userInfo");
		IVerificacionDAO verificacionDAO = new VerificacionDAOImpl();

		Collection verificados = null;
		try {
			verificados = verificacionDAO.findVerification(user.getName());
			// cf.closeConnection(verificacionDAO.getConn());
			if (verificados.size() > 0) {
				request.setAttribute("verificados", verificados);
			}
		} catch (SQLException e) {
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSUB - cwsub ********/");
			request.setAttribute("msg",
					"Ocurrio un error en la generación del reporte.");
			return mapping.findForward("success");
		}

		return mapping.findForward("success");
	}
}
